CREATE TABLE Driver (
DriverNo VARCHAR(5), NOT NULL,
FirstName CHAR(20), NOT NULL,
Surname CHAR(30), NOT NULL,
DOB date, NOT NULL,
Address VARCHAR(100), NOT NULL,
CityID VARCHAR(5), NOT NULL,
Postcode VARCHAR(10), NOT NULL,
PhoneNum VARCHAR(15), NOT NULL,
EmailAddress VARCHAR(100), NOT NULL,
LicenceNum VARCHAR(30), NOT NULL,
LicenceExpiryDate date, NOT NULL,
VehicleRegNum VARCHAR (10), NOT NULL,
CarSize VARCHAR(10), 
OfficeID VARCHAR(3), NOT NULL,
AccountNum VARCHAR(8), NOT NULL,
AccountSortCode VARCHAR(6), NOT NULL,
NIN VARCHAR(30), NOT NULL,
DateRegistered date, 
[Status] VARCHAR(20), NOT NULL);